Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyGroupID (FK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
ItemID (PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | |
ItemSellingPricesID (FK) | A unique system assigned identifier for the ItemSellingPrices. | ID_ITM_SL_PRC | Identity | integer | ItemSellingPrices(RU_ITM_SL_PRC) |
ItemSellingRuleID (FK) | A unique system assigned identifier for the ItemSellingPrices. | ID_RU_ITM_SL | Identity | integer | ItemSellingRule(RU_ITM_SL) |
POSDepartmentID (FK) | A unique system-assigned identifier for the POSDepartment | ID_DPT_PS | Identity | integer | POSDepartment(ID_DPT_PS) |
PriceLineID (FK) | A unique identifier for this price point. | ID_LN_PRC | Identity | integer | PriceLine(AS_LN_PRC) |
MerchandiseHierarchyGroupID (FK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | PriceLine(AS_LN_PRC) |
BrandName (FK) | A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. | NM_BRN | Name | varchar(40) | Brand(ID_BRN) |
AuthorizedForSaleFlag | A flag to indicate that the RETAIL STORE is authorized to stock this particular ITEM. | FL_AZN_FR_SLS | Flag | integer | |
DiscountFlag | A flag to indicate whether this ITEM can be discounted. | FL_ITM_DSC | Flag | integer | |
PriceAuditFlag | A flag to denote whether this ITEM was validated (scanned) during verification of the ITEM table. | FL_ADT_ITM_PRC | Flag | integer | |
TaxExemptCode | A code to denote the tax exemption status from sales and use tax. The codes refer to the UCC code, Tax Exempt Code, defined in data element 441. | LU_EXM_TX | Code2 | char(2) | |
UsageCode | This code defines how this item may be used within a store. Usage is a function of how an item may be consumed or disposed of by the store. | LU_ITM_USG | Code2 | char(2) | |
Name | The name by which the Item is known. | NM_ITM | Name | varchar(40) | |
Description | The textual description of the Item and its characteristics. | DE_ITM | DescriptionShort | varchar(255) | |
LongDescription | A longer textual description of the Item and its characteristics. | DE_ITM_LNG | DescriptionNarrative | varchar(4000) | |
TypeCode | This code indicates which subtype this item is. Examples are Stock Item, Aggregate Item, Service Item, Prepared Item, Group Select Item, etc. | TY_ITM | Code4 | char(4) | |
KitSetCode | This code signifies this ITEM is provided as a kit which has to made up either by the customer or by the store at an additional cost. | LU_KT_ST | Code2 | char(2) | |
SubstituteIdentifiedFlag | An ITEM for which there is a substitute available for sale within the RETAIL STORE. | FL_ITM_SBST_IDN | Flag | integer | |
OrderCollectionCode | A code to signify that this ITEM is ordered as part of a collection of ITEMs. | LU_CLN_ORD | Code2 | char(2) | |
SerializedIUnitValidationFlag | An indicator used to identify if the SERIALIZED ITEM requires operator validation after payment has been made and prior to customer pickup. | FL_VLD_SRZ_ITM | Flag | integer | |
SubBrand (FK) | A sequence number that identifies a subbrand within a brand. | AI_SUB_BRN | LineNumber | smallint | SubBrand(ID_SUB_BRN) |
SubBrand (FK) | A unique name to denote a class of ITEMs as a product. The brand can include private label ITEMs. | NM_BRN_SUB_BRN | Name | varchar(40) | SubBrand(ID_SUB_BRN) |